COVID-19 has altered the world immeasurably. Schools and many workforces have been shift to become digitized and travel has been restricted. Mask use has been mandated by the government in many areas in the United States. With no end in sight of coronavirus cases dissipating, our group stems to give a visual presentation of COVID-19 incidence rates, as well as explore the correlation between tobacco use and COVID-19 incidence on difference ethnicity as a way to promote sources that promote equity.
The datasets we analyzed were taken from John Hopkins and Yahoo Finance. After combining these datasets, our data had 154 observations and 40 columns.
The coronavirus has reached 5.04486410^{6} cases and 1.6293810^{5} since it’s inception in the United States. The worst day of COVID-19 had 4928 deaths in a single day. The day with the most cases had 7.69310^{4} cases.
Since the first COVID-19 case in the U.S, the DOW JONES index has reached a low of 1.85919310^{4} and a high of 2.95514210^{4}. The S&P 500 has reached a high of 3386.149902 and a low of 2237.399902.
The highest positive rate in a single day was 0.211 and the lowest tests per cases in a single day had reached 4.734.
This table shows a timeseries of COVID-19 cases in the United States from December 31st, 2019 to August 10th, 2020 in a month grouping. The table shows the total cases, deaths, and tests, in each month. The table also shows the average closing points of U.S market indices DOW JONES and S&P 500.
We can easily see which month had the most deaths, which also correlated to the lowest point on DOW JONES.
The table shows the slow beginning of the coronavirus has esclates exponentially within months. You can also see the market indices crash during the early onset of COVID-19, but recovering after DOW JONES reaches a low of 18591.93.
The table also shows how the number of tests being conducted each month is rapidly increasing, as the S&P 500 reaches near all time highs.
| Year | Month | total_cases | total_deaths | DOW_average | SPY_average | new_tests | positive_rate | tests_per_case |
|---|---|---|---|---|---|---|---|---|
| 2019 | 12 | 0 | 0 | 28538.44 | 3230.780 | 0 | NaN | NaN |
| 2020 | 1 | 5 | 0 | 28879.99 | 3278.203 | 0 | NaN | NaN |
| 2020 | 2 | 33 | 0 | 28519.73 | 3277.314 | 0 | NaN | NaN |
| 2020 | 3 | 111892 | 2062 | 22637.42 | 2652.394 | 794554 | 0.1121667 | 10.246167 |
| 2020 | 4 | 577137 | 40705 | 23293.90 | 2761.975 | 3654576 | 0.1790952 | 5.785048 |
| 2020 | 5 | 450083 | 28282 | 24271.02 | 2919.608 | 6944778 | 0.0784500 | 13.739550 |
| 2020 | 6 | 569508 | 16744 | 26062.27 | 3104.661 | 11056518 | 0.0515455 | 19.691364 |
| 2020 | 7 | 1342556 | 18814 | 26385.83 | 3207.619 | 16370782 | 0.0811818 | 12.378227 |
| 2020 | 8 | 310049 | 6170 | 27217.72 | 3331.633 | 3603396 | 0.0804000 | 12.461600 |
Chart 3 description